POFI-1349-01 - Spreadsheets
Lamar State College - Port Arthur
House Bill 2504
Fall 2016 Course Syllabus
Faculty Information | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Semester | Fall 2016 | ||||||||||||
Instructor | Jones, Tamalla Dayan | ||||||||||||
Phone | (409) 984-6247 | ||||||||||||
greentd1@lamarpa.edu | |||||||||||||
Department |
|
||||||||||||
Office |
|
||||||||||||
MyLamarPA | Be sure to check your campus E-mail and Course Homepage using MyLamarPA campus web portal (My.LamarPA.edu). When you’ve logged in, click the email icon in the upper right-hand corner to check email, or click on the “My Courses” tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who your academic advisor is by using MyLamarPA. | ||||||||||||
Course Information | |||||||||||||
Course Number | 91345 | ||||||||||||
Course Description | Skill development in concepts, procedures, and application of spreadsheets. This course is designed to be repeated multiple times to improve student proficiency. | ||||||||||||
Course Prerequisites | None | ||||||||||||
Required Textbooks | Benchmark Series Microsoft Excel 2013, Level 1 by Nita Rutkosky, Audrey Roggenkamp and Ian Rutkosky, published by Paradigm Publishing, ISBN 978-0-76385-390-7 | ||||||||||||
Attendance Policy |
Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily. In addition, attendance on a regular basis is necessary for proper skill development. The instructor reserves the right to drop any student missing more than two weeks of class (six MWF classes, four TR classes, and two weeks with no online class or lab participation). Quizzes may be given at the beginning of the class period. Students coming in to class late will not be allowed to take quizzes already turned in. A grade of zero will be recorded for the quiz. Tardiness is not acceptable. Frequent tardiness to class will result in a meeting between the student and instructor. Continued tardiness will result in a ten-point penalty on the student’s final course grade. Students are responsible for completing all assigned homework, including reading assignments, by the required due dates and for being prepared for each class meeting. This applies even if you were absent from the previous class meeting. |
||||||||||||
Course Grading Scale | 90 - 100=A 80 - 89=B 70 - 79=C 60 - 69=D Below 59 = F | ||||||||||||
Determination of Final Grade |
Test 60% Homework and Quizzes 15% Final Exam 25% |
||||||||||||
Final Exam Date | December 5, 2016 - 10:00 AM Through December 5, 2016 - 12:00 PM | ||||||||||||
Major Assignments |
Week 1 Chapter 1: Course Introduction, Syllabus Test, and Course Pretest Preparing an Excel Workbook Week 2 Chapter 1: Preparing an Excel Workbook Week 3 Chapter 2: Inserting Formulas in a Worksheet Week 4 Chapter 3: Enhancing a Worksheet Week 5 Chapter 3: Enhancing a Worksheet Continued (Thur. Sept 22, 2016 Test 1 Chapter 1-3) Week 6 Chapter 4: Enhancing a Worksheet Week 7 Chapter 4: Enhancing a Worksheet; Unit 1 Performance Assessment. Level 1 Week 8 Chapter 5: Moving Data within and between Workbooks Week 9 Chapter 5: Moving Data within and between Workbooks Week 10 Chapter 6: Maintaining Workbooks Week 11 Chapter 6: Maintaining Workbooks (Thurs. Nov. 3, 2016 Test 2 Chapters 4-6) Week 12 Chapter 7: Creating Charts and Inserting Formulas Week 13 Chapter 7: Enhancing the Display of Workbooks Week 14 Chapter 8: Unit 2 Performance Assessment Week 15 Review Final (Dec. 5, 2016 10-12:30 am, Chapters 7-8) |
||||||||||||
Calendar of Lecture Topics and Major Assignment Due Dates |
Week 1 Chapter 1: Creating a Worksheet, Saving a Workbook, Editing Data in a Cell, Printing a Workbook, Closing a Workbook & Closing Excel Week 2 Chapter 1: Using Automatic Entering Features, Opening a Workbook, Inserting Formulas, Selecting Cells, Applying Basic Formatting & Using Help Week 3 Chapter 2: Writing Formulas with Mathematical Operators, Inserting Formulas with Functions, Writing Formulas with Statistical Functions, Displaying Formulas, and Using Absolute and Mixed Cell References in Formulas Week 4 Chapter 3: Changing Column Width, Changing Row Height, Inserting and Deleting Cells, Rows, and Columns, Applying Formatting, and Applying a Theme Week 5 Chapter 3: Formatting Numbers, Formatting Cells Using the Format Cells Dialog Box, Formatting with Format Painter, and Hiding and Unhiding Columns and Rows Week 6 Chapter 4: Formatting a Worksheet Page, Inserting Headers and Footers, Customizing Print Jobs, and Completing a Spelling Check Week 7 Chapter 4: Using Undo and Redo, Finding and Replacing Data and Cell Formatting in a Worksheet, Sorting Data, and Filtering Data; Unit 1 Performance Assessment Week 8 Chapter 5: Creating a Workbook with Multiple Worksheets, Copying, Cutting, and Pasting Cells, Managing Worksheets Week 9 Chapter 5: Working with Ranges, Working with Windows, Moving, Linking, Copying, and Pasting Data, and Moving and Copying Data Week 10 Chapter 6: Maintaining Workbooks, Managing the Recent Workbooks List, and Managing Worksheets Week 11 Chapter 6: Formatting with Cell Styles, Inserting Hyperlinks, and Using Excel Templates Week 12 Chapter 7: Creating a Chart, Printing a Chart, Changing the Chart Design Week 13 Chapter 7: Changing Chart Formatting, Writing Formulas with Financial Functions, and Writing Formulas with the IF Logical Function Week 14 Chapter 8: Inserting Symbols and Special Characters, Inserting Images, Creating and Inserting Screenshots Inserting and Copying Shapes, Drawing and Formatting Text Boxes; Inserting a Picture as a Watermark, Inserting SmartArt Graphics, Creating, Sizing, and Moving WordArt; Unit 2 Performance Assessment Week 15 Review Final (Dec. 5, 2016 10-12:30 am, Chapters 7-8) |
||||||||||||
General Education/Core Curriculum Student Learning Outcomes |
|
||||||||||||
Program Student Learning Outcomes |
Upon successful completion of this course, the student will be able to: PSLO ALPHA: Reading skills - Demonstrates comprehension of content-area reading material. Identifies all main ideas, supporting details, and vocabulary in reading material; demonstrates a full understanding of the reading. PSLO 1. Demonstrates appropriate professionalism in the administrative workplace environment PSLO 2. Uses current business administration skills PSLO 3. Uses current business office software applications PSLO 4. Proofreads and edits business documents |
||||||||||||
Course Student Learning Outcomes |
1. Identifies all main ideas, supporting details, and vocabulary in reading material; demonstrates a full understanding of the reading (PSLO ALPHA); measured by pre- and post-tests 2. Identifies terminology and concepts associated with spreadsheet applications (PSLO 2); measured by daily assignment 3. Insert graphics and reports in worksheets (PSLO 3); measured by daily assignment 4. Create and modify workbooks (PSLO 3); measured by end-of-chapter assessment assignment 5. Create and use special functions (PSLO 3); measured by end-of-chapter assessment assignment 6. Calculate data using formulas and functions (PSLO 3); measured by daily assignment 7. Proofread and edit workbooks (PSLO 4); measured by application assignment |
||||||||||||
Academic Honesty | Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty. | ||||||||||||
Facility Policies |
|
||||||||||||
Additional Information | |||||||||||||
Important Information | |||||||||||||
ADA Considerations | The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Special Populations Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241. | ||||||||||||
Copyright Violations |
Some material in this course may be copyrighted. They may be used only for instructional purposes this semester,
by students enrolled in this course. These materials are being used fairly and legally.
No one may distribute or share these copyrighted materials in any medium or format with anyone outside this class,
including publishing essays with copyrighted material, uploading copyrighted material to Facebook or YouTube, or
painting or performing copyrighted material for public display.
Copyright violation is not the same thing as plagiarism. Plagiarism is intellectual dishonesty. Offenses of plagiarism result in lower grades or failing scores, and professors and the college strictly enforce plagiarism rules. There is never any acceptable use of plagiarism. Copyright violation is a legal offense, punishable by large fines and penalties. Copyrighted material can be used if permission from the material’s creator is obtained, or if its use meets the standards of fair use in an educational setting. For example, a student can quote a line from Shakespeare’s Hamlet in a report without violating copyright but still be guilty of plagiarism if the quotation is not properly documented. If you are in doubt about what material can be freely used, ask your professor or contact the Dean of Library Services, at (409) 984-6216. |
||||||||||||
Assessment Statement |
Assessment is a process by which LSCPA can help you learn better and gauge the level of progress you have made to
attain knowledge, skills, beliefs, and values. It also helps your professors understand how to improve teaching
and testing methods in your classes, and it helps each department understand and improve degree and certificate
programs.
Periodically LSC-PA will collect assessment data for research and reporting purposes, including statistical data and sometimes copies of your work. Be assured that all material the college uses for assessment purposes will be kept confidential. To ensure anonymity, your name will be removed from any material we use for assessment purposes, including video-recorded performances, speeches, and projects. If you object to allowing LSC-PA to use your material for assessment purposes, submit a letter stating so to your professor by the 12th class day. You will still be required to participate in whatever assessments are being done; we just won’t use your data. What’s the difference between assessment and grades? The grades you get on papers, projects, speeches, and assignments are specific types of focused assessment. LSC-PA’s assessment efforts include class grades, surveys, standardized tests, and other tools. |
||||||||||||
Privacy Notice |
Federal privacy laws apply to college students. This means that college employees, including instructors, cannot
divulge information to third parties, including parents and legal guardians of students. Even if the students are
minors, information about their college work cannot be shared with anyone except in very limited circumstances.
Anyone requesting information about a student should be referred to the Registrar. Instructors will be notified in writing by that Office about what information may be released and to whom. Please remember that releasing private information about a student, however innocuous it may seem, can be a violation of federal law, with very serious consequences. Circumstances under which information may be released:
An adult student may submit, to the Registrar, a handwritten, signed note granting permission for release of
information. The note must specify what information may be divulged, and it must specify the name of the person
to whom the information may be given.
The Registrar’s office is located in the Student Center room 303B, and can be reached at (409) 984-6165. |
||||||||||||
College-Level Perspectives |
This course helps add to the students’ overall collegiate experience in the following ways:
|
||||||||||||
Degree Plan Evaluation |
A Degree Plan Evaluation will help you determine which classes you need to complete your program.
All of the classes that you have taken that apply to your declared major will be listed on the right. If you have a class that still needs to be completed, a “NO” will be listed on the right next to the required class. |
||||||||||||
HB 2504 | This syllabus is part of LSC-PA’s efforts to comply with Texas House Bill 2504. | ||||||||||||
|